﻿CREATE TABLE [dbo].[EndPoints] (
    [ID]                     UNIQUEIDENTIFIER NOT NULL,
    [Description]            VARCHAR (255)    NULL,
    [EndpointValue]          VARCHAR (255)    NOT NULL,
    [Category]               VARCHAR (50)     NOT NULL,
    [BindingType]            VARCHAR (50)     NULL,
    [TransportType]          VARCHAR (50)     NULL,
    [TransportLocation]      VARCHAR (255)    NULL,
    [UDDIContactName]        VARCHAR (50)     NULL,
    [UDDIEmail]              VARCHAR (50)     NULL,
    [UDDIUserType]           VARCHAR (20)     NULL,
    [BiztalkApplication]     VARCHAR (255)    NOT NULL,
    [EndpointName]           VARCHAR (255)    NULL,
    [Status]                 VARCHAR (50)     NOT NULL,
    [ModifiedBy]             VARCHAR (50)     NULL,
    [TargetNamespace]        VARCHAR (255)    NULL,
    [MessageExchangePattern] VARCHAR (20)     NULL,
    [JaxRPCResponse]         BIT              NULL,
    [ServiceAction]          VARCHAR (75)     NULL,
    [CacheTimeOut]           INT              NULL,
    [RequestAction]          VARCHAR (50)     NULL,
    [ModifiedDate]           DATETIME         NULL,
    [BusinessProvider]       VARCHAR (255)    NULL,
    [ServiceName]            VARCHAR (255)    NULL
);

